﻿-- =============================================
-- Author:		<Author,,Name>
-- Create date: <Create Date,,>
-- Description:	<Description,,>
-- =============================================
create PROCEDURE [dbo].[proc_UserList_ByRootId]
	(
		@RootId NVARCHAR(50)
	)
AS
BEGIN	
  
	SELECT * FROM aspnet_Users au WHERE au.rootid=@RootId AND au.IsLockout=0
	
END